CTE Scan
Short Description
The CTE Scan node scans the result of a Common Table Expression (CTE)
Detailed Description​
The CTE Scan node scans the result of a Common Table Expression (CTE) using a WITH expression. According to pganalyze, watch out if you are running pre version 12, as these older version do not optimize the CTE materialization as part of the main query optimizing process and this can cause variable performance.
Additional Links​
- PostgreSQL Documentation - WITH Queries
- PostgreSQL Documentation - Using Explain
- pgAnalyze - Explain
- eTutorials - Understanding How PostgreSQL Executes a Query
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.